Scott Orsey ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	19

About Me

About Me

Industry	Healthcare
Area of Expertise	Operations
How I Use Smartsheet	Workflow improvements and data collection for collaborative activities

Analytics

127

Posts

164

Visits

555

Points

Dec 1, 2020

Join Date

Jun 21, 2024

Last Active

Reactions

• Insightful 8

  8
• Vote Up 26

  26
• Awesome 18

  18

• Activity
• Discussions7
• Comments120

• Re: How to count the number of photo shoots, not completed, by brand? COMPLEX???

  Scott Orsey

  03/26/24
  Hi @Shawn_K2 , Have you attempted to create a report and specifying the filters that you listed? If not I would try that route first to see if that meets your need. Within reports, I would recommend …
  1 ·

• Re: I want to return a value in another sheet if both criteria on my my sheet is met. Using Vlookup

  Scott Orsey

  03/21/24
  Hi @Zelda CARZELRD , Unfortunately you cannot put two conditions into a VLOOKUP like that. Instead, you'll want to look into COLLECT() which allows you to grab the values for every row that meets you…
  1 ·

• Re: Remove the need for duplicate reports in a dashboard

  Scott Orsey

  03/21/24
  HI @KLoom , I feel your pain. If you have a relatively small set of projects, and you don't plan to add any new projects, then your approach is probably the easiest. Just bite the bullet and build ou…
  1 ·

Previous